CREATE DATABASE Blue_Pumpkin
GO
USE Blue_Pumpkin
GO
CREATE TABLE UserInfo
(
	Email varchar(50) PRIMARY KEY,
	Fullname nvarchar(50)
	 
)
GO
CREATE TABLE UserLogin
(	
	Email varchar(50) PRIMARY KEY REFERENCES UserInfo(Email),
	[Password] nvarchar(50) DEFAULT '123456'
)
GO

INSERT INTO UserInfo VALUES('admin','Giza')
INSERT INTO UserLogin(Email) VALUES ('admin')
GO
SELECT *FROM UserLogin
SELECT u.Email,u.Password FROM UserLogin as u WHERE u.password = '123456' AND u.email = 'admin'
GO
